/*
 * vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4 foldmethod=marker:
 *
 * qills.c
 *
 * C.C.Allison
 * chris.allison@hotmail.com
 *
 * Started: Monday 14 January 2013, 04:33:33
 * Version: 0.00
 * Revision: $Id: qills.c 2 2013-01-14 05:39:03Z chris.charles.allison@gmail.com $
 * Last Modified: Monday 14 January 2013, 04:38:27
 */

#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>

main() {
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;
    char *server = "localhost";
    char *user = "root";
    char *password = ""; /* set me first */
    char *database = "mysql";
    conn = mysql_init(NULL);
    /* Connect to database */
    if (!mysql_real_connect(conn, server,
                user, password, database, 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }
    /* send SQL query */
    if (mysql_query(conn, "show tables")) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }
    res = mysql_use_result(conn);
    /* output table name */
    printf("MySQL Tables in mysql database:\n");
    while ((row = mysql_fetch_row(res)) != NULL)
        printf("%s \n", row[0]);
    /* close connection */
    mysql_free_result(res);
    mysql_close(conn);
}
